
INSERT INTO pp_cities VALUES (1, 'Sumy');
INSERT INTO pp_cities VALUES (2, 'Los Angeles');
INSERT INTO pp_cities VALUES (3, 'Chicago');
INSERT INTO pp_cities VALUES (4, 'Houston');
INSERT INTO pp_cities VALUES (5, 'New York');
INSERT INTO pp_cities VALUES (6, 'Phoenix');
INSERT INTO pp_cities VALUES (7, 'Detroit');
INSERT INTO pp_cities VALUES (8, 'Philadelphia');
INSERT INTO pp_cities VALUES (9, 'San Francisco');
INSERT INTO pp_cities VALUES (10, 'Indianapolis');
INSERT INTO pp_cities VALUES (11, 'Columbus');
INSERT INTO pp_cities VALUES (12, 'Las Vegas');
INSERT INTO pp_cities VALUES (13, 'Columbus');
INSERT INTO pp_cities VALUES (14, 'Atlanta');
INSERT INTO pp_cities VALUES (15, 'Kansas City');
INSERT INTO pp_cities VALUES (16, 'Oakland');
INSERT INTO pp_cities VALUES (17, 'Omaha');
INSERT INTO pp_cities VALUES (18, 'Long Beach');
INSERT INTO pp_cities VALUES (19, 'Mesa');
INSERT INTO pp_cities VALUES (20, 'Virginia Beach');
INSERT INTO pp_cities VALUES (21, 'Miami');
INSERT INTO pp_cities VALUES (22, 'Cleveland');
INSERT INTO pp_cities VALUES (23, 'Raleigh');
INSERT INTO pp_cities VALUES (24, 'Colorado Springs');
INSERT INTO pp_cities VALUES (25, 'Tulsa');
INSERT INTO pp_cities VALUES (26, 'Minneapolis');
INSERT INTO pp_cities VALUES (27, 'Arlington');
INSERT INTO pp_cities VALUES (28, 'Honolulu');
INSERT INTO pp_cities VALUES (29, 'Wichita');
INSERT INTO pp_cities VALUES (30, 'St. Louis');
INSERT INTO pp_cities VALUES (31, 'New Orleans');
INSERT INTO pp_cities VALUES (32, 'Santa Ana');
INSERT INTO pp_cities VALUES (33, 'Anaheim');
INSERT INTO pp_cities VALUES (34, 'Washington');
INSERT INTO pp_cities VALUES (35, 'Newark');
INSERT INTO pp_cities VALUES (36, 'Plano');
INSERT INTO pp_cities VALUES (37, 'Buffalo');


INSERT INTO pp_categories VALUES (1, null, 'Musical Instruments');
INSERT INTO pp_categories VALUES (2, null,'Electronics');
INSERT INTO pp_categories VALUES (3, null,'Job');
INSERT INTO pp_categories VALUES (4, null,'Everything Else');



INSERT INTO pp_categories VALUES (101, 1, 'Guitars');
INSERT INTO pp_categories VALUES (102, 1, 'Electronic Instruments');
INSERT INTO pp_categories VALUES (103, 1, 'Piano');
INSERT INTO pp_categories VALUES (104, 1, 'String');

INSERT INTO pp_categories VALUES (201, 101, 'Acoustic' );
INSERT INTO pp_categories VALUES (202, 101, 'Acoustic Electric');
INSERT INTO pp_categories VALUES (203, 101, 'Electric');
INSERT INTO pp_categories VALUES (204, 101, 'Bass');

INSERT INTO pp_categories VALUES (205, 102, 'Drum Machines');
INSERT INTO pp_categories VALUES (206, 102, 'Electronic Keyboards');
INSERT INTO pp_categories VALUES (207, 102, 'Synthesizers');

INSERT INTO pp_categories VALUES (208, 103, 'Organ');
INSERT INTO pp_categories VALUES (209, 103, 'Piano');
INSERT INTO pp_categories VALUES (210, 103, 'Grand Piano');

INSERT INTO pp_categories VALUES (211, 104, 'Viola');




INSERT INTO pp_categories VALUES (105, 2,'Audio');
INSERT INTO pp_categories VALUES (106, 2, 'Televisions');
INSERT INTO pp_categories VALUES (107, 2, 'Video Games');
INSERT INTO pp_categories VALUES (108, 2, 'Telephones');
INSERT INTO pp_categories VALUES (109, 2, 'Computers');
INSERT INTO pp_categories VALUES (110, 2, 'Cameras and Photo');

INSERT INTO pp_advertisement VALUES (
Adv_sq.nextval,
102,
5,
TO_DATE('2010-03-24','YYYY.MM.DD'),
'Casio Cps 100 piano 61 keys original made in japan Buo po mga keys nito parang piano na din buong buo tunog walang problema sa unit kht konti (in excellent contion) lahat ng keys and buttons functional makinis pa po unit actual pic ang mga nsa baba.   7.5k only just txt or call me... 0542251730');


select * from pp_categories;
select * from pp_cities;
select * from pp_advertisement;


















